Pandas Profiling Report

Dataset statistics

Number of variables	10
Number of observations	214
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1
Duplicate rows (%)	0.5%
Total size in memory	16.8 KiB
Average record size in memory	80.6 B

Variable types

NUM	10

Warnings

Dataset has 1 (0.5%) duplicate rows	Duplicates
`Mg` has 42 (19.6%) zeros	Zeros
`K` has 30 (14.0%) zeros	Zeros
`Ba` has 176 (82.2%) zeros	Zeros
`Fe` has 144 (67.3%) zeros	Zeros

Reproduction

Analysis started	2021-11-15 15:19:31.641191
Analysis finished	2021-11-15 15:19:50.965063
Duration	19.32 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

RI
Real number (ℝ_≥0)

Distinct	178
Distinct (%)	83.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.518365421
Minimum	1.51115
Maximum	1.53393
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	1.51115
5-th percentile	1.515401
Q1	1.5165225
median	1.51768
Q3	1.5191575
95-th percentile	1.523664
Maximum	1.53393
Range	0.02278
Interquartile range (IQR)	0.002635

Descriptive statistics

Standard deviation	0.003036863739
Coefficient of variation (CV)	0.002000087527
Kurtosis	4.931737386
Mean	1.518365421
Median Absolute Deviation (MAD)	0.001265
Skewness	1.625430506
Sum	324.9302
Variance	9.222541372e-06
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.52152	3	1.4%
1.51645	3	1.4%
1.5159	3	1.4%
1.52213	2	0.9%
1.51763	2	0.9%
1.51779	2	0.9%
1.51769	2	0.9%
1.51793	2	0.9%
1.51613	2	0.9%
1.51618	2	0.9%
Other values (168)	191	89.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.51115	1	0.5%
1.51131	1	0.5%
1.51215	1	0.5%
1.51299	1	0.5%
1.51316	1	0.5%

Value	Count	Frequency (%)
1.53393	1	0.5%
1.53125	1	0.5%
1.52777	1	0.5%
1.52739	1	0.5%
1.52725	1	0.5%

Na
Real number (ℝ_≥0)

Distinct	142
Distinct (%)	66.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13.40785047
Minimum	10.73
Maximum	17.38
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	10.73
5-th percentile	12.415
Q1	12.9075
median	13.3
Q3	13.825
95-th percentile	14.8535
Maximum	17.38
Range	6.65
Interquartile range (IQR)	0.9175

Descriptive statistics

Standard deviation	0.8166035557
Coefficient of variation (CV)	0.06090488238
Kurtosis	3.052232409
Mean	13.40785047
Median Absolute Deviation (MAD)	0.435
Skewness	0.4541814537
Sum	2869.28
Variance	0.6668413672
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	5	2.3%
13.02	5	2.3%
13.21	5	2.3%
12.85	4	1.9%
13.64	4	1.9%
13.24	4	1.9%
12.86	4	1.9%
13.33	4	1.9%
12.93	3	1.4%
13.2	3	1.4%
Other values (132)	173	80.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10.73	1	0.5%
11.02	1	0.5%
11.03	1	0.5%
11.23	1	0.5%
11.45	1	0.5%

Value	Count	Frequency (%)
17.38	1	0.5%
15.79	1	0.5%
15.15	1	0.5%
15.01	1	0.5%
14.99	1	0.5%

Mg
Real number (ℝ_≥0)

ZEROS

Distinct	94
Distinct (%)	43.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.68453271
Minimum	0
Maximum	4.49
Zeros	42
Zeros (%)	19.6%
Memory size	1.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.115
median	3.48
Q3	3.6
95-th percentile	3.85
Maximum	4.49
Range	4.49
Interquartile range (IQR)	1.485

Descriptive statistics

Standard deviation	1.442407845
Coefficient of variation (CV)	0.5373031364
Kurtosis	-0.4103189629
Mean	2.68453271
Median Absolute Deviation (MAD)	0.205
Skewness	-1.152559318
Sum	574.49
Variance	2.080540391
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	42	19.6%
3.54	8	3.7%
3.48	8	3.7%
3.58	8	3.7%
3.52	7	3.3%
3.62	5	2.3%
3.5	4	1.9%
3.66	4	1.9%
3.61	4	1.9%
3.56	4	1.9%
Other values (84)	120	56.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	42	19.6%
0.33	1	0.5%
0.78	1	0.5%
1.01	1	0.5%
1.35	1	0.5%

Value	Count	Frequency (%)
4.49	1	0.5%
3.98	1	0.5%
3.97	1	0.5%
3.93	1	0.5%
3.9	3	1.4%

Al
Real number (ℝ_≥0)

Distinct	118
Distinct (%)	55.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.444906542
Minimum	0.29
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	0.29
5-th percentile	0.696
Q1	1.19
median	1.36
Q3	1.63
95-th percentile	2.394
Maximum	3.5
Range	3.21
Interquartile range (IQR)	0.44

Descriptive statistics

Standard deviation	0.4992696456
Coefficient of variation (CV)	0.3455376739
Kurtosis	2.060568969
Mean	1.444906542
Median Absolute Deviation (MAD)	0.21
Skewness	0.907289809
Sum	309.21
Variance	0.249270179
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.54	8	3.7%
1.19	6	2.8%
1.29	5	2.3%
1.43	5	2.3%
1.23	5	2.3%
1.56	5	2.3%
1.36	4	1.9%
1.35	4	1.9%
1.28	4	1.9%
1.62	3	1.4%
Other values (108)	165	77.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.29	1	0.5%
0.34	1	0.5%
0.47	2	0.9%
0.51	1	0.5%
0.56	2	0.9%

Value	Count	Frequency (%)
3.5	1	0.5%
3.04	1	0.5%
3.02	1	0.5%
2.88	1	0.5%
2.79	1	0.5%

Si
Real number (ℝ_≥0)

Distinct	133
Distinct (%)	62.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	72.65093458
Minimum	69.81
Maximum	75.41
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	69.81
5-th percentile	71.315
Q1	72.28
median	72.79
Q3	73.0875
95-th percentile	73.5175
Maximum	75.41
Range	5.6
Interquartile range (IQR)	0.8075

Descriptive statistics

Standard deviation	0.7745457948
Coefficient of variation (CV)	0.0106611952
Kurtosis	2.967902956
Mean	72.65093458
Median Absolute Deviation (MAD)	0.385
Skewness	-0.7304472251
Sum	15547.3
Variance	0.5999211882
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
72.86	4	1.9%
73.28	4	1.9%
73.1	4	1.9%
72.99	4	1.9%
73.11	4	1.9%
72.97	3	1.4%
72.95	3	1.4%
73.01	3	1.4%
72.64	3	1.4%
72.96	3	1.4%
Other values (123)	179	83.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
69.81	1	0.5%
69.89	1	0.5%
70.16	1	0.5%
70.26	1	0.5%
70.43	1	0.5%

Value	Count	Frequency (%)
75.41	1	0.5%
75.18	1	0.5%
74.55	1	0.5%
74.45	1	0.5%
73.88	1	0.5%

K
Real number (ℝ_≥0)

ZEROS

Distinct	65
Distinct (%)	30.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4970560748
Minimum	0
Maximum	6.21
Zeros	30
Zeros (%)	14.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.1225
median	0.555
Q3	0.61
95-th percentile	0.76
Maximum	6.21
Range	6.21
Interquartile range (IQR)	0.4875

Descriptive statistics

Standard deviation	0.6521918456
Coefficient of variation (CV)	1.312109194
Kurtosis	54.68969853
Mean	0.4970560748
Median Absolute Deviation (MAD)	0.115
Skewness	6.55164831
Sum	106.37
Variance	0.4253542034
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	30	14.0%
0.57	12	5.6%
0.6	11	5.1%
0.56	11	5.1%
0.58	10	4.7%
0.64	8	3.7%
0.61	8	3.7%
0.59	7	3.3%
0.54	6	2.8%
0.62	6	2.8%
Other values (55)	105	49.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	30	14.0%
0.02	1	0.5%
0.03	1	0.5%
0.04	2	0.9%
0.05	1	0.5%

Value	Count	Frequency (%)
6.21	2	0.9%
2.7	1	0.5%
1.76	1	0.5%
1.68	1	0.5%
1.46	1	0.5%

Ca
Real number (ℝ_≥0)

Distinct	143
Distinct (%)	66.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8.956962617
Minimum	5.43
Maximum	16.19
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	5.43
5-th percentile	7.8125
Q1	8.24
median	8.6
Q3	9.1725
95-th percentile	11.5615
Maximum	16.19
Range	10.76
Interquartile range (IQR)	0.9325

Descriptive statistics

Standard deviation	1.423153487
Coefficient of variation (CV)	0.1588879566
Kurtosis	6.681977951
Mean	8.956962617
Median Absolute Deviation (MAD)	0.445
Skewness	2.047053913
Sum	1916.79
Variance	2.025365848
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.03	5	2.3%
8.43	5	2.3%
9.57	4	1.9%
8.44	4	1.9%
8.79	4	1.9%
8.38	3	1.4%
8.83	3	1.4%
8.67	3	1.4%
8.39	3	1.4%
8.53	3	1.4%
Other values (133)	177	82.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5.43	1	0.5%
5.79	1	0.5%
5.87	1	0.5%
6.47	1	0.5%
6.65	1	0.5%

Value	Count	Frequency (%)
16.19	1	0.5%
14.96	1	0.5%
14.68	1	0.5%
14.4	1	0.5%
13.44	1	0.5%

Ba
Real number (ℝ_≥0)

ZEROS

Distinct	34
Distinct (%)	15.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.175046729
Minimum	0
Maximum	3.15
Zeros	176
Zeros (%)	82.2%
Memory size	1.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1.57
Maximum	3.15
Range	3.15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4972192606
Coefficient of variation (CV)	2.840494441
Kurtosis	12.54108358
Mean	0.175046729
Median Absolute Deviation (MAD)	0
Skewness	3.416424569
Sum	37.46
Variance	0.2472269931
Monotocity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	176	82.2%
1.57	2	0.9%
0.64	2	0.9%
0.09	2	0.9%
1.59	2	0.9%
0.11	2	0.9%
0.15	1	0.5%
1.55	1	0.5%
0.61	1	0.5%
0.63	1	0.5%
Other values (24)	24	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	176	82.2%
0.06	1	0.5%
0.09	2	0.9%
0.11	2	0.9%
0.14	1	0.5%

Value	Count	Frequency (%)
3.15	1	0.5%
2.88	1	0.5%
2.2	1	0.5%
1.71	1	0.5%
1.68	1	0.5%

Fe
Real number (ℝ_≥0)

ZEROS

Distinct	32
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.05700934579
Minimum	0
Maximum	0.51
Zeros	144
Zeros (%)	67.3%
Memory size	1.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.1
95-th percentile	0.267
Maximum	0.51
Range	0.51
Interquartile range (IQR)	0.1

Descriptive statistics

Standard deviation	0.09743870064
Coefficient of variation (CV)	1.709170651
Kurtosis	2.662015617
Mean	0.05700934579
Median Absolute Deviation (MAD)	0
Skewness	1.75432747
Sum	12.2
Variance	0.009494300382
Monotocity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
0	144	67.3%
0.17	7	3.3%
0.24	7	3.3%
0.09	6	2.8%
0.1	5	2.3%
0.11	4	1.9%
0.07	3	1.4%
0.14	3	1.4%
0.28	3	1.4%
0.16	3	1.4%
Other values (22)	29	13.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	144	67.3%
0.01	1	0.5%
0.03	1	0.5%
0.05	1	0.5%
0.06	1	0.5%

Value	Count	Frequency (%)
0.51	1	0.5%
0.37	1	0.5%
0.35	1	0.5%
0.34	1	0.5%
0.32	1	0.5%

Type
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.780373832
Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.103738646
Coefficient of variation (CV)	0.7566387736
Kurtosis	-0.2795182977
Mean	2.780373832
Median Absolute Deviation (MAD)	1
Skewness	1.114915201
Sum	595
Variance	4.425716292
Monotocity	Increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	76	35.5%
1	70	32.7%
7	29	13.6%
3	17	7.9%
5	13	6.1%
6	9	4.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	70	32.7%
2	76	35.5%
3	17	7.9%
5	13	6.1%
6	9	4.2%

Value	Count	Frequency (%)
7	29	13.6%
6	9	4.2%
5	13	6.1%
3	17	7.9%
2	76	35.5%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	RI	Na	Mg	Al	Si	K	Ca	Fe	Type
0	1.52101	13.64	4.49	1.10	71.78	0.06	8.75	0.00	1
1	1.51761	13.89	3.60	1.36	72.73	0.48	7.83	0.00	1
2	1.51618	13.53	3.55	1.54	72.99	0.39	7.78	0.00	1
3	1.51766	13.21	3.69	1.29	72.61	0.57	8.22	0.00	1
4	1.51742	13.27	3.62	1.24	73.08	0.55	8.07	0.00	1
5	1.51596	12.79	3.61	1.62	72.97	0.64	8.07	0.26	1
6	1.51743	13.30	3.60	1.14	73.09	0.58	8.17	0.00	1
7	1.51756	13.15	3.61	1.05	73.24	0.57	8.24	0.00	1
8	1.51918	14.04	3.58	1.37	72.08	0.56	8.30	0.00	1
9	1.51755	13.00	3.60	1.36	72.99	0.57	8.40	0.11	1

Last rows

	RI	Na	Al	Si	K	Ca	Ba	Type
204	1.51617	14.95	2.27	73.30	0.00	8.71	0.67	7
205	1.51732	14.95	1.80	72.99	0.00	8.61	1.55	7
206	1.51645	14.94	1.87	73.11	0.00	8.67	1.38	7
207	1.51831	14.39	1.82	72.86	1.41	6.47	2.88	7
208	1.51640	14.37	2.74	72.85	0.00	9.45	0.54	7
209	1.51623	14.14	2.88	72.61	0.08	9.18	1.06	7
210	1.51685	14.92	1.99	73.06	0.00	8.40	1.59	7
211	1.52065	14.36	2.02	73.42	0.00	8.44	1.64	7
212	1.51651	14.38	1.94	73.61	0.00	8.48	1.57	7
213	1.51711	14.23	2.08	73.36	0.00	8.62	1.67	7

Most frequent

	RI	Na	Mg	Al	Si	K	Ca	Ba	Fe	Type	count
0	1.52213	14.21	3.82	0.47	71.77	0.11	9.57	0.0	0.0	1	2

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent